import pandas as pd
list = [[100,120,105],[95,110,108],[98,80,100],[112,106,97]]
index = ['王蒙','李珊','赵胜','刘文']
columns = ['语文','数学','英语']
df = pd.DataFrame(list, index,columns)
print('保存到 ”scorel” 工作表中的数据: \n', df)
writer = pd.ExcelWriter('Score.xlsx')
df.to_excel(writer, sheet_name='scorel')
df.iloc[0] = [105, 118, 100]
print('保存到 “score2” 工作表中的数据: \n', df)
df.to_excel(writer, sheet_name='score2')
writer._save()
df1 = pd.read_excel('Score.xlsx',sheet_name=['scorel', 'score2'],index_col=0)
print('导入的数据: \n', df1)
